Show All
When I click the Refresh button, a message tells me that my macro changes will be lost.
This message appears when you have made changes to a macro in the Visual Basic Editor and have also changed the copy of your workbook in the Microsoft Script Editor.
To save the changes to your macro, do the following:
on the Refresh toolbar.While recording a macro, I recorded an action I didn't want.
To undo an unwanted action in a macro, you can open the macro in the Visual Basic Editor and remove any unwanted steps.
If you don't want to use the Visual Basic Editor, record the macro again without the unwanted action.
A macro I recorded sometimes produces an error message.
A macro you record may not run properly in every situation. If the macro cannot run, Microsoft Excel displays an error message. Some macros depend on certain options or settings in Excel. For example, a macro that searches for bold text won't run properly if bold text isn't displayed. If a macro you've recorded produces an error message, note the error number. You can then search for "error messages" in Visual Basic Help and find information about the message you received.